<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Adding a quick threshold to a report</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
p.whs3 { margin-left:0px; }
img_whs4 { border:none; height:16px; float:none; width:18px; border-style:none; }
p.whs5 { margin-left:40px; }
img_whs6 { border:none; width:29px; height:15px; float:none; border-style:none; }
p.whs7 { font-weight:bold; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs3 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nAdding features for users\nHighlighting specific sets of data: Thresholds\nCreating a quick threshold");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a quick threshold</h1>
<p>You can add quick thresholds to a report when you do not need more complex 
 conditions and formatting for a threshold. Quick thresholds apply green, 
 red, or yellow colors or symbols to metric values on your report. Thresholds 
 allow you to easily distinguish metric values that fall within certain 
 ranges.</p>
<p>Quick thresholds are convenient because they allow you to just click 
 once to quickly scan the top, bottom, and middle ranges of values on a 
 report. Quick thresholds are based on predefined ranges of numbers in 
 MicroStrategy Web, and therefore allow only limited formatting. You can 
 create your own thresholds and conditional formatting options; see 
<a 
 HREF="Create_simple_threshold.htm">Creating a simple threshold</a> and 
 
<a HREF="Create_advanced_threshold.htm">Creating an advanced threshold</a>.</p>
<p>Quick threshold formatting is applied according to the following metric 
 value ranges. By default, quick thresholds are ranked in descending order. 
 </p>
<ul type="disc" class="whs1">
	
<li class=p><p>Green: The top 20% of the metric values </p></li>
	
<li class=p><p>Red: The bottom 20% of the metric values </p></li>
	
<li class=p><p>Yellow: (Optional) The middle range of the metric values.</p></li>
</ul>
<p>For example, if you enable quick thresholds on a report that shows daily 
 revenue data, values that fall within the top 20% of revenue are highlighted 
 in green, while values in the lowest 20% are highlighted in red. </p>
<h2>To display quick thresholds on a grid report </h2>
<ol type="1" class="whs2">
	
<li class=p><p class="whs3">Run a report.</p></li>
	
<li class=p><p>Select a metric header on the grid report. To select 
 multiple metric headers, hold <span style="font-weight: bold;"><B>CTRL </B></span>and 
 select the headers.</p></li>
	
<li class=p><p>Select <span style="font-weight: bold;"><B>Data</B></span> 
 on the menu bar.</p></li>
</ol>
<ol start="4" type="1" class="whs2">
	
<li class=p><p>Do one of the following:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>To highlight 
 cells in green and red, click <span style="font-weight: bold;"><B>Quick Thresholds</B></span> 
 <img src="images/thresholdquick.gif" x-maintain-ratio="TRUE" height="16px" width="18px" border="0" class="img_whs4"> 
 on the toolbar. </p></li>
	</ul>
</ol>
<ul type="disc" class="whs1">
	
<li class=p><p class="whs5">To have a symbol replace 
 metric values that fall within a range of values, click the arrow next 
 to <span style="font-weight: bold;"><B>Quick Thresholds</B></span> <img src="images/thresholdquickmenu.gif" x-maintain-ratio="TRUE" width="29px" height="15px" border="0" class="img_whs6"> 
 and select the symbol to display on the report, according to the following: 
 </p></li>
	<ul type="disc" class="whs1">
		
<li style="list-style: square;" type=square class=p><p class="whs5">To 
 replace all metric values with green, red, and yellow symbols, select 
 a yellow symbol.</p></li>
		
<li style="list-style: square;" type=square class=p><p class="whs5">To 
 replace only the top and bottom 20% ranges with green and red, select 
 a red or green symbol. The middle-range metric values are not replaced 
 with a symbol.</p></li>
	</ul>
</ul>
<p class="whs7">Related topics</p>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Thresholds_on_report.htm">Displaying thresholds 
 on a report</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Thresholds.htm">About 
 thresholds</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_simple_threshold.htm">Creating 
 a threshold for a metric based on a metric: Visual thresholds</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_advanced_threshold.htm">Creating 
 a threshold for multiple metrics: Advanced thresholds</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
